<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>Fetch the next row and return it as an object</title>
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-base.css" />
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-medium.css" />

 </head>
 <body class="docs"><div class="navbar navbar-fixed-top">
  <div class="navbar-inner clearfix">
    <ul class="nav" style="width: 100%">
      <li style="float: left;"><a href="function.cubrid-fetch-lengths.html">« cubrid_fetch_lengths</a></li>
      <li style="float: right;"><a href="function.cubrid-fetch-row.html">cubrid_fetch_row »</a></li>
    </ul>
  </div>
</div>
<div id="breadcrumbs" class="clearfix">
  <ul class="breadcrumbs-container">
    <li><a href="index.html">PHP Manual</a></li>
    <li><a href="cubridmysql.cubrid.html">CUBRID MySQL 兼容性函数</a></li>
    <li>Fetch the next row and return it as an object</li>
  </ul>
</div>
<div id="layout">
  <div id="layout-content"><div id="function.cubrid-fetch-object" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">cubrid_fetch_object</h1>
  <p class="verinfo">(PECL CUBRID &gt;= 8.3.0)</p><p class="refpurpose"><span class="refname">cubrid_fetch_object</span> &mdash; <span class="dc-title">Fetch the next row and return it as an object</span></p>

 </div>

 <div class="refsect1 description" id="refsect1-function.cubrid-fetch-object-description">
  <h3 class="title">说明</h3>
  <div class="methodsynopsis dc-description">
   <span class="methodname"><strong>cubrid_fetch_object</strong></span>(<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">resource</span> <code class="parameter">$result</code></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">string</span> <code class="parameter">$class_name</code><span class="initializer"> = ?</span></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">array</span> <code class="parameter">$params</code><span class="initializer"> = ?</span></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">int</span> <code class="parameter">$type</code><span class="initializer"> = ?</span></span><br>): <span class="type">object</span></div>

  <p class="para rdfs-comment">
    This function returns an object with the column names of the result set as
    properties. The values of these properties are extracted from the current
    row of the result. 
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-function.cubrid-fetch-object-parameters">
 <h3 class="title">参数</h3>
 <p class="para">
  <dl>
  
   <dt>
<code class="parameter">result</code></dt>

   <dd>
<p class="para"><code class="parameter">result</code> comes from a call to <span class="function"><a href="function.cubrid-execute.html" class="function">cubrid_execute()</a></span></p></dd>

  
  
    <dt>
<code class="parameter">class_name</code></dt>

      <dd>

       <p class="para">
        The name of the class to instantiate. If not specified, a
        <span class="classname"><a href="class.stdclass.html" class="classname">stdClass</a></span> (stdClass is PHP&#039;s generic empty class
        that&#039;s used when casting other types to objects) object is returned.
       </p>
     </dd>

   
    
     <dt>
<code class="parameter">params</code></dt>

      <dd>

       <p class="para">
        An optional <span class="type">array</span> of parameters to pass to the constructor
        for <code class="parameter">class_name</code> objects.
       </p>
     </dd>

   
    
     <dt>
<code class="parameter">type</code></dt>

      <dd>

       <p class="para">
        Type can only be CUBRID_LOB, this parameter will be used only when you
        need to operate the lob object.
       </p>
     </dd>

   
  </dl>

  </p>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-function.cubrid-fetch-object-returnvalues">
  <h3 class="title">返回值</h3>
  <p class="para">
    An object, when process is successful.
  </p>
   <p class="para">
    <strong><code>false</code></strong>, when there are no more rows; NULL, when process is unsuccessful.
  </p>
 </div>


 <div class="refsect1 examples" id="refsect1-function.cubrid-fetch-object-examples">
  <h3 class="title">范例</h3>
  <div class="example" id="example-1192">
   <p><strong>示例 #1 <span class="function"><strong>cubrid_fetch_object()</strong></span> example</strong></p>
   <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$conn&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">cubrid_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">33000</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"demodb"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$res&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">cubrid_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$conn</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;*&nbsp;FROM&nbsp;code"</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">cubrid_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">));<br /><br /></span><span style="color: #FF8000">//&nbsp;if&nbsp;you&nbsp;want&nbsp;to&nbsp;operate&nbsp;LOB&nbsp;object,&nbsp;you&nbsp;can&nbsp;use&nbsp;cubrid_fetch_object($res,&nbsp;CUBRID_LOB)<br /><br /></span><span style="color: #007700">class&nbsp;</span><span style="color: #0000BB">demodb_code&nbsp;</span><span style="color: #007700">{<br />&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;</span><span style="color: #0000BB">$s_name&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">null</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;</span><span style="color: #0000BB">$f_name&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">null</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;</span><span style="color: #0000BB">toString</span><span style="color: #007700">()&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;}<br />}<br /><br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">cubrid_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"demodb_code"</span><span style="color: #007700">));<br /><br /></span><span style="color: #FF8000">//&nbsp;if&nbsp;you&nbsp;want&nbsp;to&nbsp;operate&nbsp;LOB&nbsp;object,&nbsp;you&nbsp;can&nbsp;use&nbsp;cubrid_fetch_object($res,&nbsp;"demodb_code",&nbsp;CUBRID_LOB)<br /><br /></span><span style="color: #007700">class&nbsp;</span><span style="color: #0000BB">demodb_code_construct&nbsp;</span><span style="color: #007700">extends&nbsp;</span><span style="color: #0000BB">demodb_code&nbsp;</span><span style="color: #007700">{<br />&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;</span><span style="color: #0000BB">__construct</span><span style="color: #007700">(</span><span style="color: #0000BB">$s</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$f</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">s_name&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$s</span><span style="color: #007700">;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">f_name&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$f</span><span style="color: #007700">;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;<br />}<br /><br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">cubrid_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'demodb_code_construct'</span><span style="color: #007700">,&nbsp;array(</span><span style="color: #DD0000">'s_name'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'f_name'</span><span style="color: #007700">)));<br /><br /></span><span style="color: #FF8000">//&nbsp;if&nbsp;you&nbsp;want&nbsp;to&nbsp;operate&nbsp;LOB&nbsp;object,&nbsp;you&nbsp;can&nbsp;use&nbsp;cubrid_fetch_object($res,&nbsp;'demodb_code_construct',&nbsp;array('s_name',&nbsp;'f_name'),&nbsp;CUBRID_LOB)<br /><br /><br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">cubrid_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">));<br /><br /></span><span style="color: #0000BB">cubrid_close_request</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">cubrid_disconnect</span><span style="color: #007700">(</span><span style="color: #0000BB">$conn</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</code></div>
   </div>

    <div class="example-contents"><p>以上例程会输出：</p></div>
    <div class="example-contents screen">
<div class="cdata"><pre>
object(stdClass)#1 (2) {
  [&quot;s_name&quot;]=&gt;
  string(1) &quot;X&quot;
  [&quot;f_name&quot;]=&gt;
  string(5) &quot;Mixed&quot;
}
object(demodb_code)#1 (2) {
  [&quot;s_name&quot;]=&gt;
  string(1) &quot;W&quot;
  [&quot;f_name&quot;]=&gt;
  string(5) &quot;Woman&quot;
}
object(demodb_code_construct)#1 (2) {
  [&quot;s_name&quot;]=&gt;
  string(6) &quot;s_name&quot;
  [&quot;f_name&quot;]=&gt;
  string(6) &quot;f_name&quot;
}
object(stdClass)#1 (2) {
  [&quot;s_name&quot;]=&gt;
  string(1) &quot;B&quot;
  [&quot;f_name&quot;]=&gt;
  string(6) &quot;Bronze&quot;
}
</pre></div>
    </div>
  </div>
 </div>


 <div class="refsect1 seealso" id="refsect1-function.cubrid-fetch-object-seealso">
  <h3 class="title">参见</h3>
  <p class="para">
   <ul class="simplelist">
   <li class="member"><span class="function"><a href="function.cubrid-execute.html" class="function" rel="rdfs-seeAlso">cubrid_execute()</a> - Execute a prepared SQL statement</span></li>
   <li class="member"><span class="function"><a href="function.cubrid-fetch.html" class="function" rel="rdfs-seeAlso">cubrid_fetch()</a> - Fetch the next row from a result set</span></li>
   <li class="member"><span class="function"><a href="function.cubrid-fetch-array.html" class="function" rel="rdfs-seeAlso">cubrid_fetch_array()</a> - Fetch a result row as an associative array, a numeric array, or both</span></li>
   <li class="member"><span class="function"><a href="function.cubrid-fetch-assoc.html" class="function" rel="rdfs-seeAlso">cubrid_fetch_assoc()</a> - Return the associative array that corresponds to the fetched row</span></li>
   <li class="member"><span class="function"><a href="function.cubrid-fetch-row.html" class="function" rel="rdfs-seeAlso">cubrid_fetch_row()</a> - Return a numerical array with the values of the current row</span></li>
   </ul>
  </p>
 </div>


</div></div></div></body></html>